﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ExportUMacKeepList.aspx.cs" Inherits="IHISCETeim.Web.MachineSys.UserModel.ExportExecl.ExportUMacKeepList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:repeater id="rpMenu" runat="server">
        <HeaderTemplate>
        <table border=1 style=" border-color:#000;" width="2000">                   
        <thead>
            <tr  >                   
                <th  orderField="SerialNumber" class="asc" width="80">
                    机号
                </th>
                <th orderField="IntoDate" class="asc" width="80">
                    交机日期
                </th>
                
                <th width="90">
                    经销商
                </th>
                <th  align="center"  width="90">
                    客户
                </th>  
                <th   width="90">手机</th>
                <th   width="120">地址</th>
                <th width="120">
                    一期费用
                </th>
                <th width="120">
                    二期费用
                </th>
                <th align="center" width="110">
                    50H
                </th>
                <th align="center" width="110">
                    250H
                </th> 
                <th align="center" width="110">
                    500H
                </th> 
                <th align="center" width="110">
                    750H
                </th>
                <th align="center" width="110">
                    1000H
                </th> 
                <th align="center" width="110">
                    1250H
                </th>   
                    <th align="center" width="110">
                    1500H
                </th>
                    <th align="center" width="110">
                    1750H
                </th>
                <th align="center" width="110">
                    2000H
                </th>  
                <th>完成率</th>  
                 <th >扣罚次数</th>                          
            </tr>
        </thead>
        <tbody>
        </HeaderTemplate>
        <ItemTemplate>
            <tr target="sid_user" rel="<%# Eval("SerialNumber") %>"> 
				<td >
                     <%# Eval("SerialNumber")%>
                </td>
                <td >
                    <%# Convert.ToDateTime(Eval("IntoDate")).ToShortDateString()%>
                </td>  
                <td ><%# Eval("AgentName")%></td>
				<td ><%# Eval("CustomerName")%></td>
			    <td><%# Eval("CustomerMobile")%></td>
                 <td><%# Eval("CustomerAddress")%></td>
                <td title="" ><%# Eval("FirstCost")%>|<%# Eval("FirstCostDate")%></td>
                <td title="" ><%# Eval("SecondCost")%>|<%# Eval("SecondCostDate")%></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),50) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),250) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),500) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),750) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),1000) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),1250) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),1500) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),1750) %></td>
                <td ><%# GetUMacKeepDetail2( Eval("SerialNumber"),2000) %></td> 
                <td >
                    <%# GetPer(Eval("YZCS"),Eval("DQYZCS"))%> %                 
                </td>   
                <td>
                     <%# Eval("khxm") %>
                </td>                              
			</tr>
        </ItemTemplate>
        <FooterTemplate>
            <tr>
                <td colspan="6" align="right"></td>
                <td colspan="10" class="">
                    合计:<b style="color:red;">需保养次数:<%=sumdt.Rows[0]["allkeeptime"]%>,已保养次数:<%=sumdt.Rows[0]["keepedtime"]%></b>
                    总保养完成率：  <%= Convert.ToDecimal(sumdt.Rows[0]["allkeeptime"]) == 0 ? "0" : ((Convert.ToDecimal(sumdt.Rows[0]["keepedtime"]) / Convert.ToDecimal(sumdt.Rows[0]["allkeeptime"])) * 100).ToString("F0") + "%"%>
                </td>
            </tr>
        </tbody>
    </table>
    </FooterTemplate> 
    </asp:repeater>
    </form>
</body>
</html>
